Film_Locations_in_San_Francisco

Data source: data.sfgov.org

36 rows where Release Year = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Fun Facts, Production Company, Distributor, Director, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
521 521 Forrest Gump 98 1994 48 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Paramount Pictures 4 Paramount Pictures 3 Robert Zemeckis 89 Eric Roth 90 Tom Hanks 305 Robin Wright 78  
563 563 Getting Even with Dad 103 1994 48 California & Grant Streets   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Dutch 94 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
564 564 Getting Even with Dad 103 1994 48 War Memorial Building (401 Van Ness Avenue)   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
565 565 Getting Even with Dad 103 1994 48 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
566 566 Getting Even with Dad 103 1994 48 140 Maiden Lane   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
567 567 Getting Even with Dad 103 1994 48 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
568 568 Getting Even with Dad 103 1994 48 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
569 569 Getting Even with Dad 103 1994 48 Mason Street at Jackson   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
570 570 Getting Even with Dad 103 1994 48 M.H. de Young Memorial Museum (Golden Gate Park)   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
571 571 Getting Even with Dad 103 1994 48 Embarcadero Street Station- BART   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
572 572 Getting Even with Dad 103 1994 48 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
611 611 Golden Gate 107 1994 48 Ross Alley (Chinatown) Ross Alley is the oldest alley in San Francisco. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
612 612 Golden Gate 107 1994 48 University of California Hastings College of the Law   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
613 613 Golden Gate 107 1994 48 Bush Street (between Grant & Kearny Streets)   American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
614 614 Golden Gate 107 1994 48 Buena Vista Park (Haight Street at Buena Vista) Established in 1867, Buena Vista Park is the oldest official park in San Francisco. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
615 615 Golden Gate 107 1994 48 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
680 680 Interview With The Vampire 133 1994 48 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
681 681 Interview With The Vampire 133 1994 48 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
682 682 Interview With The Vampire 133 1994 48 100 Market Street at 6th Street   Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
683 683 Interview With The Vampire 133 1994 48 6th Street On-ramp to Highway 280   Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
723 723 Junior 142 1994 48 2552 Hyde Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
724 724 Junior 142 1994 48 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
725 725 Junior 142 1994 48 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
726 726 Junior 142 1994 48 Hyatt Fisherman's Wharf (555 Northpoint Street)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
727 727 Junior 142 1994 48 Fairmont Hotel (950 Mason Street, Nob Hill)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
728 728 Junior 142 1994 48 Chinatown Gate Designed in 1970, the Chinatown Gate (aka the Dragon Gate) is based on ceremonial gates found in Chinese villages. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
729 729 Junior 142 1994 48 722 Steiner Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
976 976 Nina Takes a Lover 177 1994 48     Alan Jacobs Productions 112 Columbia TriStar Home Video 47 Alan Jacobs 132 Alan Jacobs 133 Laura San Giacomo 347 Paul Rhys 134  
1590 1590 When a Man Loves a Woman 302 1994 48 Buena Vista Café (2765 Hyde Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1591 1591 When a Man Loves a Woman 302 1994 48 Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1592 1592 When a Man Loves a Woman 302 1994 48 Spring Valley School (1451 Jackson Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1593 1593 When a Man Loves a Woman 302 1994 48 International Studies Academy (993 Vermont Street, Potrero Hill)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1594 1594 When a Man Loves a Woman 302 1994 48 Grant Street at Pacific Avenue   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1595 1595 When a Man Loves a Woman 302 1994 48 Cybelle's Pizza (1000 Bush Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1596 1596 When a Man Loves a Woman 302 1994 48 766 Vallejo Street at Stockton Street (North Beach)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1597 1597 When a Man Loves a Woman 302 1994 48 1521 Masonic Avenue at Piedmont Street   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 33.712ms · Data source: data.sfgov.org